﻿CREATE TABLE [dbo].[Patient]
(
[PatientIDKey] [int] NOT NULL IDENTITY(1, 1),
[PatientHierarchicalIDNumber] [nvarchar] (12) NULL,
[PatientHierarchicalParentIDNumber] [nvarchar] (12) NULL,
[PatientHierarchicalLevelCode] [nvarchar] (2) NULL,
[PatientHierarchicalChildCode] [nvarchar] (1) NULL,
[IndividualRelationshipCode] [nvarchar] (2) NULL,
[EntityIdentifierCode] [nvarchar] (3) NULL,
[EntityTypeQualifier] [nvarchar] (1) NULL,
[PatientLastName] [nvarchar] (35) NULL,
[PatientFirstName] [nvarchar] (25) NULL,
[PatientMiddleName] [nvarchar] (25) NULL,
[PatientNameSuffix] [nvarchar] (10) NULL,
[PatientIdentificationCodeQualifier] [nvarchar] (2) NULL,
[PatientPrimaryIdentifier] [nvarchar] (80) NULL,
[PatientAddressLine1] [nvarchar] (55) NULL,
[PatientAddressLine2] [nvarchar] (55) NULL,
[PatientCityName] [nvarchar] (30) NULL,
[PatientStateCode] [nvarchar] (2) NULL,
[PatientPostalCode] [nvarchar] (15) NULL,
[PatientCountryCode] [nvarchar] (3) NULL,
[PatientGenderCode] [nvarchar] (1) NULL,
[PatientBirthDate] [nvarchar] (35) NULL,
[ReferenceIdentificationQualifier] [nvarchar] (3) NULL,
[PatientSecondaryIdentifier] [nvarchar] (30) NULL,
[PropertyAndCasualtyRefIdQualifier] [nvarchar] (3) NULL,
[PropertyCasualtyClaimNumber] [nvarchar] (30) NULL,
[EDIMessageType] [nvarchar] (50) NULL,
[GroupControlNumber] [nvarchar] (9) NULL,
[SubscriberPrimaryIdentifier] [nvarchar] (80) NULL,
[TransactionSetControlNumber] [nvarchar] (9) NULL,
[HierarchicalIDNumber] [int] NULL,
[InterchangeControlNumber] [nvarchar] (9) NULL,
[TransactionSetIDKey] [int] NULL,
[BTSMessageID] [nvarchar] (100) NULL,
[BTSInterchangeID] [nvarchar] (100) NULL
) ON [PRIMARY]


